A php second-level linkage with a database. ****************************************: Php level-2 linkage menu ********************** author: * Email: ***/*********************************** ********
*************
*************************
* Email: njj@nuc.edu.cn **************
* ******** Date: 2004/10/02 ******************
* ********* Reserve the copyright information when you reprint it **************
**************************************** ***/
Re
Sometimes write a program when the background requirements to import large amounts of data into the database, such as computer test results of the query, phone book data, etc. are generally stored in Excel, then we can export data into a CSV file, and then through the following procedures can be in the background batch import data into the database.
The following are just the main program sections:
/*****************************************Author: Chong Xing/arcow****************
Someone asked, for example, if the data table contains sortid characters ranging from A1 to A29. If "order by sortid" is added to the query, the sorting will be A1, A10, a11... a19, A2 ,.. a29, A3, a4... a9
How can we make it output in the order of A1, A2, a3... A28, A29?
Create a test tableCreate Table 'test _ njj '('Id' int (10) Not null auto_increment,'Sortid' varchar (20) not null,'User _ id' int (10) Not null default '0 ',Primary Key ('id '))
Data sometimes write a program when the background requirements to import a large number of data into the database, such as computer test results of the query, phone book data are generally stored in Excel, when we can export data into a CSV file, and then through the following program can be in the background batch import data into the database.
The following are just the main program sections:
/*****************************************Author: Chong Xing/arcow****************
The following are just the main program sections:
The code is as follows
Copy Code
/*****************************************Author: Chong Xing/arcow****************njj@nuc.edu.cn*******************PHP import CSV file to database **********Simultaneous calculation of program execution time ***********www.111cn.net***************************************************/Define Get Time functionfunction Getmicrotime () {List ($us
When writing a program when the background requirements to import a large number of data into the database, such as computer test results of the query, phone book data are generally stored in Excel, when we can export data into a CSV file, and then through the following program can be in the background batch import data into the database.
The following are just the main program sections:
/*****************************************Author: Chong Xing/arcow****************
Sometimes write a program when the background requirements to import large amounts of data into the database, such as computer test results of the query, phone book data, etc. are generally stored in Excel, then we can export data into a CSV file, and then through the following procedures can be in the background batch import data into the database.
The following are just the main program sections:
The code is as follows
Copy Code
/******************************
Sometimes write a program when the background requirements to import large amounts of data into the database, such as computer test results of the query, phone book data, etc. are generally stored in Excel, then we can export data into a CSV file, and then through the following procedures can be in the background batch import data into the database.
The following are just the main program sections:
/*****************************************Author: Chong Xing/arcow****************
Sometimes write a program when the background requirements to import a large number of data into the database, such as computer test results of the query, phone book data are generally stored in Excel, when we can export data into a CSV file, and then through the following program can be in the background batch import data into the database.
The following are just the main program sections:
/*****************************************Author: Chong Xing/arcow****************
Contact Us
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.